<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "https://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/>
<meta http-equiv="X-UA-Compatible" content="IE=9"/>
<meta name="generator" content="Doxygen 1.8.17"/>
<meta name="viewport" content="width=device-width, initial-scale=1"/>
<title>Aestate: aestate/opera/DBPool/steady_pg.py Source File</title>
<link href="tabs.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="jquery.js"></script>
<script type="text/javascript" src="dynsections.js"></script>
<link href="search/search.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="search/searchdata.js"></script>
<script type="text/javascript" src="search/search.js"></script>
<link href="doxygen.css" rel="stylesheet" type="text/css" />
</head>
<body>
<div id="top"><!-- do not remove this div, it is closed by doxygen! -->
<div id="titlearea">
<table cellspacing="0" cellpadding="0">
 <tbody>
 <tr style="height: 56px;">
  <td id="projectalign" style="padding-left: 0.5em;">
   <div id="projectname">Aestate
   &#160;<span id="projectnumber">1.0.5</span>
   </div>
  </td>
 </tr>
 </tbody>
</table>
</div>
<!-- end header part -->
<!-- Generated by Doxygen 1.8.17 -->
<script type="text/javascript">
/* @license magnet:?xt=urn:btih:cf05388f2679ee054f2beb29a391d25f4e673ac3&amp;dn=gpl-2.0.txt GPL-v2 */
var searchBox = new SearchBox("searchBox", "search",false,'Search');
/* @license-end */
</script>
<script type="text/javascript" src="menudata.js"></script>
<script type="text/javascript" src="menu.js"></script>
<script type="text/javascript">
/* @license magnet:?xt=urn:btih:cf05388f2679ee054f2beb29a391d25f4e673ac3&amp;dn=gpl-2.0.txt GPL-v2 */
$(function() {
  initMenu('',true,false,'search.php','Search');
  $(document).ready(function() { init_search(); });
});
/* @license-end */</script>
<div id="main-nav"></div>
<!-- window showing the filter options -->
<div id="MSearchSelectWindow"
     onmouseover="return searchBox.OnSearchSelectShow()"
     onmouseout="return searchBox.OnSearchSelectHide()"
     onkeydown="return searchBox.OnSearchSelectKey(event)">
</div>

<!-- iframe showing the search results (closed by default) -->
<div id="MSearchResultsWindow">
<iframe src="javascript:void(0)" frameborder="0" 
        name="MSearchResults" id="MSearchResults">
</iframe>
</div>

<div id="nav-path" class="navpath">
  <ul>
<li class="navelem"><a class="el" href="dir_374ee6e3281d8312d956f1f155302869.html">aestate</a></li><li class="navelem"><a class="el" href="dir_3d2a62c9f0038653f55551d1ba6b2e78.html">opera</a></li><li class="navelem"><a class="el" href="dir_222c18a5940c41eb83d2a46ecf15e75c.html">DBPool</a></li>  </ul>
</div>
</div><!-- top -->
<div class="header">
  <div class="headertitle">
<div class="title">steady_pg.py</div>  </div>
</div><!--header-->
<div class="contents">
<a href="steady__pg_8py.html">Go to the documentation of this file.</a><div class="fragment"><div class="line"><a name="l00001"></a><span class="lineno"><a class="line" href="namespaceaestate_1_1opera_1_1_d_b_pool_1_1steady__pg.html">    1</a></span>&#160;<span class="stringliteral">&quot;&quot;&quot;SteadyPg - hardened classic PyGreSQL connections.</span></div>
<div class="line"><a name="l00002"></a><span class="lineno">    2</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00003"></a><span class="lineno">    3</span>&#160;<span class="stringliteral">Implements steady connections to a PostgreSQL database</span></div>
<div class="line"><a name="l00004"></a><span class="lineno">    4</span>&#160;<span class="stringliteral">using the classic (not DB-API 2 compliant) PyGreSQL API.</span></div>
<div class="line"><a name="l00005"></a><span class="lineno">    5</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00006"></a><span class="lineno">    6</span>&#160;<span class="stringliteral">The connections are transparently reopened when they are</span></div>
<div class="line"><a name="l00007"></a><span class="lineno">    7</span>&#160;<span class="stringliteral">closed or the database connection has been lost or when</span></div>
<div class="line"><a name="l00008"></a><span class="lineno">    8</span>&#160;<span class="stringliteral">they are used more often than an optional usage limit.</span></div>
<div class="line"><a name="l00009"></a><span class="lineno">    9</span>&#160;<span class="stringliteral">Only connections which have been marked as being in a database</span></div>
<div class="line"><a name="l00010"></a><span class="lineno">   10</span>&#160;<span class="stringliteral">transaction with a begin() call will not be silently replaced.</span></div>
<div class="line"><a name="l00011"></a><span class="lineno">   11</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00012"></a><span class="lineno">   12</span>&#160;<span class="stringliteral">A typical situation where database connections are lost</span></div>
<div class="line"><a name="l00013"></a><span class="lineno">   13</span>&#160;<span class="stringliteral">is when the database server or an intervening firewall is</span></div>
<div class="line"><a name="l00014"></a><span class="lineno">   14</span>&#160;<span class="stringliteral">shutdown and restarted for maintenance reasons.  In such a</span></div>
<div class="line"><a name="l00015"></a><span class="lineno">   15</span>&#160;<span class="stringliteral">case, all database connections would become unusable, even</span></div>
<div class="line"><a name="l00016"></a><span class="lineno">   16</span>&#160;<span class="stringliteral">though the database service may be already available again.</span></div>
<div class="line"><a name="l00017"></a><span class="lineno">   17</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00018"></a><span class="lineno">   18</span>&#160;<span class="stringliteral">The &quot;hardened&quot; connections provided by this module will</span></div>
<div class="line"><a name="l00019"></a><span class="lineno">   19</span>&#160;<span class="stringliteral">make the database connections immediately available again.</span></div>
<div class="line"><a name="l00020"></a><span class="lineno">   20</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00021"></a><span class="lineno">   21</span>&#160;<span class="stringliteral">This results in a steady PostgreSQL connection that can be used</span></div>
<div class="line"><a name="l00022"></a><span class="lineno">   22</span>&#160;<span class="stringliteral">by PooledPg or PersistentPg to create pooled or persistent</span></div>
<div class="line"><a name="l00023"></a><span class="lineno">   23</span>&#160;<span class="stringliteral">connections to a PostgreSQL database in a threaded environment</span></div>
<div class="line"><a name="l00024"></a><span class="lineno">   24</span>&#160;<span class="stringliteral">such as the application server of &quot;Webware for Python.&quot;</span></div>
<div class="line"><a name="l00025"></a><span class="lineno">   25</span>&#160;<span class="stringliteral">Note, however, that the connections themselves are not thread-safe.</span></div>
<div class="line"><a name="l00026"></a><span class="lineno">   26</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00027"></a><span class="lineno">   27</span>&#160;<span class="stringliteral">For more information on PostgreSQL, see:</span></div>
<div class="line"><a name="l00028"></a><span class="lineno">   28</span>&#160;<span class="stringliteral">    https://www.postgresql.org/</span></div>
<div class="line"><a name="l00029"></a><span class="lineno">   29</span>&#160;<span class="stringliteral">For more information on PyGreSQL, see:</span></div>
<div class="line"><a name="l00030"></a><span class="lineno">   30</span>&#160;<span class="stringliteral">    http://www.pygresql.org</span></div>
<div class="line"><a name="l00031"></a><span class="lineno">   31</span>&#160;<span class="stringliteral">For more information on Webware for Python, see:</span></div>
<div class="line"><a name="l00032"></a><span class="lineno">   32</span>&#160;<span class="stringliteral">    https://webwareforpython.github.io/w4py/</span></div>
<div class="line"><a name="l00033"></a><span class="lineno">   33</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00034"></a><span class="lineno">   34</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00035"></a><span class="lineno">   35</span>&#160;<span class="stringliteral">Usage:</span></div>
<div class="line"><a name="l00036"></a><span class="lineno">   36</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00037"></a><span class="lineno">   37</span>&#160;<span class="stringliteral">You can use the class SteadyPgConnection in the same way as you</span></div>
<div class="line"><a name="l00038"></a><span class="lineno">   38</span>&#160;<span class="stringliteral">would use the class DB from the classic PyGreSQL API module db.</span></div>
<div class="line"><a name="l00039"></a><span class="lineno">   39</span>&#160;<span class="stringliteral">The only difference is that you may specify a usage limit as the</span></div>
<div class="line"><a name="l00040"></a><span class="lineno">   40</span>&#160;<span class="stringliteral">first parameter when you open a connection (set it to None</span></div>
<div class="line"><a name="l00041"></a><span class="lineno">   41</span>&#160;<span class="stringliteral">if you prefer unlimited usage), and an optional list of commands</span></div>
<div class="line"><a name="l00042"></a><span class="lineno">   42</span>&#160;<span class="stringliteral">that may serve to prepare the session as the second parameter,</span></div>
<div class="line"><a name="l00043"></a><span class="lineno">   43</span>&#160;<span class="stringliteral">and you can specify whether is is allowed to close the connection</span></div>
<div class="line"><a name="l00044"></a><span class="lineno">   44</span>&#160;<span class="stringliteral">(by default this is true).  When the connection to the PostgreSQL</span></div>
<div class="line"><a name="l00045"></a><span class="lineno">   45</span>&#160;<span class="stringliteral">database is lost or has been used too often, it will be automatically</span></div>
<div class="line"><a name="l00046"></a><span class="lineno">   46</span>&#160;<span class="stringliteral">reset, without further notice.</span></div>
<div class="line"><a name="l00047"></a><span class="lineno">   47</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00048"></a><span class="lineno">   48</span>&#160;<span class="stringliteral">    from dbutils.steady_pg import SteadyPgConnection</span></div>
<div class="line"><a name="l00049"></a><span class="lineno">   49</span>&#160;<span class="stringliteral">    db = SteadyPgConnection(10000, [&quot;set datestyle to german&quot;],</span></div>
<div class="line"><a name="l00050"></a><span class="lineno">   50</span>&#160;<span class="stringliteral">        host=..., dbname=..., user=..., ...)</span></div>
<div class="line"><a name="l00051"></a><span class="lineno">   51</span>&#160;<span class="stringliteral">    ...</span></div>
<div class="line"><a name="l00052"></a><span class="lineno">   52</span>&#160;<span class="stringliteral">    result = db.query(&#39;...&#39;)</span></div>
<div class="line"><a name="l00053"></a><span class="lineno">   53</span>&#160;<span class="stringliteral">    ...</span></div>
<div class="line"><a name="l00054"></a><span class="lineno">   54</span>&#160;<span class="stringliteral">    db.close()</span></div>
<div class="line"><a name="l00055"></a><span class="lineno">   55</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00056"></a><span class="lineno">   56</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00057"></a><span class="lineno">   57</span>&#160;<span class="stringliteral">Ideas for improvement:</span></div>
<div class="line"><a name="l00058"></a><span class="lineno">   58</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00059"></a><span class="lineno">   59</span>&#160;<span class="stringliteral">* Alternatively to the maximum number of uses,</span></div>
<div class="line"><a name="l00060"></a><span class="lineno">   60</span>&#160;<span class="stringliteral">  implement a maximum time to live for connections.</span></div>
<div class="line"><a name="l00061"></a><span class="lineno">   61</span>&#160;<span class="stringliteral">* Optionally log usage and loss of connection.</span></div>
<div class="line"><a name="l00062"></a><span class="lineno">   62</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00063"></a><span class="lineno">   63</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00064"></a><span class="lineno">   64</span>&#160;<span class="stringliteral">Copyright, credits and license:</span></div>
<div class="line"><a name="l00065"></a><span class="lineno">   65</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00066"></a><span class="lineno">   66</span>&#160;<span class="stringliteral">* Contributed as supplement for Webware for Python and PyGreSQL</span></div>
<div class="line"><a name="l00067"></a><span class="lineno">   67</span>&#160;<span class="stringliteral">  by Christoph Zwerschke in September 2005</span></div>
<div class="line"><a name="l00068"></a><span class="lineno">   68</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00069"></a><span class="lineno">   69</span>&#160;<span class="stringliteral">Licensed under the MIT license.</span></div>
<div class="line"><a name="l00070"></a><span class="lineno">   70</span>&#160;<span class="stringliteral">&quot;&quot;&quot;</span></div>
<div class="line"><a name="l00071"></a><span class="lineno">   71</span>&#160; </div>
<div class="line"><a name="l00072"></a><span class="lineno">   72</span>&#160;<span class="keyword">from</span> pg <span class="keyword">import</span> DB <span class="keyword">as</span> PgConnection</div>
<div class="line"><a name="l00073"></a><span class="lineno">   73</span>&#160; </div>
<div class="line"><a name="l00074"></a><span class="lineno">   74</span>&#160;<span class="keyword">from</span> . <span class="keyword">import</span> __version__</div>
<div class="line"><a name="l00075"></a><span class="lineno">   75</span>&#160; </div>
<div class="line"><a name="l00076"></a><span class="lineno">   76</span>&#160;<span class="keywordflow">try</span>:</div>
<div class="line"><a name="l00077"></a><span class="lineno"><a class="line" href="namespaceaestate_1_1opera_1_1_d_b_pool_1_1steady__pg.html#a6bc78b5ffe124177861013270b31004e">   77</a></span>&#160;    baseint = (int, long)</div>
<div class="line"><a name="l00078"></a><span class="lineno">   78</span>&#160;<span class="keywordflow">except</span> NameError:  <span class="comment"># Python 3</span></div>
<div class="line"><a name="l00079"></a><span class="lineno">   79</span>&#160;    baseint = int</div>
<div class="line"><a name="l00080"></a><span class="lineno">   80</span>&#160; </div>
<div class="line"><a name="l00081"></a><span class="lineno">   81</span>&#160; </div>
<div class="line"><a name="l00082"></a><span class="lineno"><a class="line" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_error.html">   82</a></span>&#160;<span class="keyword">class </span><a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_error.html">SteadyPgError</a>(Exception):</div>
<div class="line"><a name="l00083"></a><span class="lineno">   83</span>&#160;    <span class="stringliteral">&quot;&quot;&quot;General SteadyPg error.&quot;&quot;&quot;</span></div>
<div class="line"><a name="l00084"></a><span class="lineno">   84</span>&#160; </div>
<div class="line"><a name="l00085"></a><span class="lineno">   85</span>&#160; </div>
<div class="line"><a name="l00086"></a><span class="lineno"><a class="line" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_invalid_connection.html">   86</a></span>&#160;<span class="keyword">class </span><a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_invalid_connection.html">InvalidConnection</a>(<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_error.html">SteadyPgError</a>):</div>
<div class="line"><a name="l00087"></a><span class="lineno">   87</span>&#160;    <span class="stringliteral">&quot;&quot;&quot;Database connection is invalid.&quot;&quot;&quot;</span></div>
<div class="line"><a name="l00088"></a><span class="lineno">   88</span>&#160; </div>
<div class="line"><a name="l00089"></a><span class="lineno">   89</span>&#160; </div>
<div class="line"><a name="l00090"></a><span class="lineno"><a class="line" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html">   90</a></span>&#160;<span class="keyword">class </span><a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html">SteadyPgConnection</a>:</div>
<div class="line"><a name="l00091"></a><span class="lineno">   91</span>&#160;    <span class="stringliteral">&quot;&quot;&quot;Class representing steady connections to a PostgreSQL database.</span></div>
<div class="line"><a name="l00092"></a><span class="lineno">   92</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00093"></a><span class="lineno">   93</span>&#160;<span class="stringliteral">    Underlying the connection is a classic PyGreSQL pg API database</span></div>
<div class="line"><a name="l00094"></a><span class="lineno">   94</span>&#160;<span class="stringliteral">    connection which is reset if the connection is lost or used too often.</span></div>
<div class="line"><a name="l00095"></a><span class="lineno">   95</span>&#160;<span class="stringliteral">    Thus the resulting connection is steadier (&quot;tough and self-healing&quot;).</span></div>
<div class="line"><a name="l00096"></a><span class="lineno">   96</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00097"></a><span class="lineno">   97</span>&#160;<span class="stringliteral">    If you want the connection to be persistent in a threaded environment,</span></div>
<div class="line"><a name="l00098"></a><span class="lineno">   98</span>&#160;<span class="stringliteral">    then you should not deal with this class directly, but use either the</span></div>
<div class="line"><a name="l00099"></a><span class="lineno">   99</span>&#160;<span class="stringliteral">    PooledPg module or the PersistentPg module to get the connections.</span></div>
<div class="line"><a name="l00100"></a><span class="lineno">  100</span>&#160;<span class="stringliteral">    &quot;&quot;&quot;</span></div>
<div class="line"><a name="l00101"></a><span class="lineno">  101</span>&#160; </div>
<div class="line"><a name="l00102"></a><span class="lineno"><a class="line" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#aea2beda3892f04d57f50e540740ba028">  102</a></span>&#160;    version = __version__</div>
<div class="line"><a name="l00103"></a><span class="lineno">  103</span>&#160; </div>
<div class="line"><a name="l00104"></a><span class="lineno"><a class="line" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a36c68c399eb77d8031565f82e9630540">  104</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a36c68c399eb77d8031565f82e9630540">__init__</a>(</div>
<div class="line"><a name="l00105"></a><span class="lineno">  105</span>&#160;            self, maxusage=None, setsession=None, closeable=True,</div>
<div class="line"><a name="l00106"></a><span class="lineno">  106</span>&#160;            *args, **kwargs):</div>
<div class="line"><a name="l00107"></a><span class="lineno">  107</span>&#160;        <span class="stringliteral">&quot;&quot;&quot;Create a &quot;tough&quot; PostgreSQL connection.</span></div>
<div class="line"><a name="l00108"></a><span class="lineno">  108</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00109"></a><span class="lineno">  109</span>&#160;<span class="stringliteral">        maxusage: maximum usage limit for the underlying PyGreSQL connection</span></div>
<div class="line"><a name="l00110"></a><span class="lineno">  110</span>&#160;<span class="stringliteral">            (number of uses, 0 or None means unlimited usage)</span></div>
<div class="line"><a name="l00111"></a><span class="lineno">  111</span>&#160;<span class="stringliteral">            When this limit is reached, the connection is automatically reset.</span></div>
<div class="line"><a name="l00112"></a><span class="lineno">  112</span>&#160;<span class="stringliteral">        setsession: optional list of SQL commands that may serve to prepare</span></div>
<div class="line"><a name="l00113"></a><span class="lineno">  113</span>&#160;<span class="stringliteral">            the session, e.g. [&quot;set datestyle to ...&quot;, &quot;set time zone ...&quot;]</span></div>
<div class="line"><a name="l00114"></a><span class="lineno">  114</span>&#160;<span class="stringliteral">        closeable: if this is set to false, then closing the connection will</span></div>
<div class="line"><a name="l00115"></a><span class="lineno">  115</span>&#160;<span class="stringliteral">            be silently ignored, but by default the connection can be closed</span></div>
<div class="line"><a name="l00116"></a><span class="lineno">  116</span>&#160;<span class="stringliteral">        args, kwargs: the parameters that shall be used to establish</span></div>
<div class="line"><a name="l00117"></a><span class="lineno">  117</span>&#160;<span class="stringliteral">            the PostgreSQL connections with PyGreSQL using pg.DB()</span></div>
<div class="line"><a name="l00118"></a><span class="lineno"><a class="line" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a2888f08a359c08d37a2752805cb7511f">  118</a></span>&#160;<span class="stringliteral">        &quot;&quot;&quot;</span></div>
<div class="line"><a name="l00119"></a><span class="lineno"><a class="line" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#ae85c40e9aa9781ac7d8fdedbef6c2d86">  119</a></span>&#160;        <span class="comment"># basic initialization to make finalizer work</span></div>
<div class="line"><a name="l00120"></a><span class="lineno">  120</span>&#160;        self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a2888f08a359c08d37a2752805cb7511f">_con</a> = <span class="keywordtype">None</span></div>
<div class="line"><a name="l00121"></a><span class="lineno">  121</span>&#160;        self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#ae85c40e9aa9781ac7d8fdedbef6c2d86">_closed</a> = <span class="keyword">True</span></div>
<div class="line"><a name="l00122"></a><span class="lineno">  122</span>&#160;        <span class="comment"># proper initialization of the connection</span></div>
<div class="line"><a name="l00123"></a><span class="lineno">  123</span>&#160;        <span class="keywordflow">if</span> maxusage <span class="keywordflow">is</span> <span class="keywordtype">None</span>:</div>
<div class="line"><a name="l00124"></a><span class="lineno">  124</span>&#160;            maxusage = 0</div>
<div class="line"><a name="l00125"></a><span class="lineno"><a class="line" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a8a7f70255537edb3269127924edeb0d6">  125</a></span>&#160;        <span class="keywordflow">if</span> <span class="keywordflow">not</span> isinstance(maxusage, baseint):</div>
<div class="line"><a name="l00126"></a><span class="lineno"><a class="line" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a449791883d467ffa5ec59f064a215cbe">  126</a></span>&#160;            <span class="keywordflow">raise</span> TypeError(<span class="stringliteral">&quot;&#39;maxusage&#39; must be an integer value.&quot;</span>)</div>
<div class="line"><a name="l00127"></a><span class="lineno"><a class="line" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a96596fafba584aa9ef023d40cdf75733">  127</a></span>&#160;        self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a8a7f70255537edb3269127924edeb0d6">_maxusage</a> = maxusage</div>
<div class="line"><a name="l00128"></a><span class="lineno">  128</span>&#160;        self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a449791883d467ffa5ec59f064a215cbe">_setsession_sql</a> = setsession</div>
<div class="line"><a name="l00129"></a><span class="lineno"><a class="line" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a58bb438b542ef47ccc93018fffc59464">  129</a></span>&#160;        self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a96596fafba584aa9ef023d40cdf75733">_closeable</a> = closeable</div>
<div class="line"><a name="l00130"></a><span class="lineno">  130</span>&#160;        self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a2888f08a359c08d37a2752805cb7511f">_con</a> = PgConnection(*args, **kwargs)</div>
<div class="line"><a name="l00131"></a><span class="lineno">  131</span>&#160;        self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a58bb438b542ef47ccc93018fffc59464">_transaction</a> = <span class="keyword">False</span></div>
<div class="line"><a name="l00132"></a><span class="lineno"><a class="line" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#aa1ca602a90359ca6ab85dee23b6c272f">  132</a></span>&#160;        self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#ae85c40e9aa9781ac7d8fdedbef6c2d86">_closed</a> = <span class="keyword">False</span></div>
<div class="line"><a name="l00133"></a><span class="lineno">  133</span>&#160;        self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a25fbdaacc83bdca3812d6f2d90f6abcf">_setsession</a>()</div>
<div class="line"><a name="l00134"></a><span class="lineno">  134</span>&#160;        self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#aa1ca602a90359ca6ab85dee23b6c272f">_usage</a> = 0</div>
<div class="line"><a name="l00135"></a><span class="lineno">  135</span>&#160; </div>
<div class="line"><a name="l00136"></a><span class="lineno"><a class="line" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a4ed3a76224573ad1f57299573d92f080">  136</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a4ed3a76224573ad1f57299573d92f080">__enter__</a>(self):</div>
<div class="line"><a name="l00137"></a><span class="lineno">  137</span>&#160;        <span class="stringliteral">&quot;&quot;&quot;Enter the runtime context. This will start a transaction.&quot;&quot;&quot;</span></div>
<div class="line"><a name="l00138"></a><span class="lineno">  138</span>&#160;        self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a998a2f8834ffb7e037a34dc6b6a35f5f">begin</a>()</div>
<div class="line"><a name="l00139"></a><span class="lineno">  139</span>&#160;        <span class="keywordflow">return</span> self</div>
<div class="line"><a name="l00140"></a><span class="lineno">  140</span>&#160; </div>
<div class="line"><a name="l00141"></a><span class="lineno"><a class="line" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a384a69210d735cbf8d5fce77aadc9610">  141</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a384a69210d735cbf8d5fce77aadc9610">__exit__</a>(self, *exc):</div>
<div class="line"><a name="l00142"></a><span class="lineno">  142</span>&#160;        <span class="stringliteral">&quot;&quot;&quot;Exit the runtime context. This will end the transaction.&quot;&quot;&quot;</span></div>
<div class="line"><a name="l00143"></a><span class="lineno">  143</span>&#160;        <span class="keywordflow">if</span> exc[0] <span class="keywordflow">is</span> <span class="keywordtype">None</span> <span class="keywordflow">and</span> exc[1] <span class="keywordflow">is</span> <span class="keywordtype">None</span> <span class="keywordflow">and</span> exc[2] <span class="keywordflow">is</span> <span class="keywordtype">None</span>:</div>
<div class="line"><a name="l00144"></a><span class="lineno">  144</span>&#160;            self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#ad6e454534d5834aba8b9552e209602fd">commit</a>()</div>
<div class="line"><a name="l00145"></a><span class="lineno">  145</span>&#160;        <span class="keywordflow">else</span>:</div>
<div class="line"><a name="l00146"></a><span class="lineno">  146</span>&#160;            self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a08e7af97b9d6bfc6a72abe5384405c87">rollback</a>()</div>
<div class="line"><a name="l00147"></a><span class="lineno">  147</span>&#160; </div>
<div class="line"><a name="l00148"></a><span class="lineno"><a class="line" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a25fbdaacc83bdca3812d6f2d90f6abcf">  148</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a25fbdaacc83bdca3812d6f2d90f6abcf">_setsession</a>(self):</div>
<div class="line"><a name="l00149"></a><span class="lineno">  149</span>&#160;        <span class="stringliteral">&quot;&quot;&quot;Execute the SQL commands for session preparation.&quot;&quot;&quot;</span></div>
<div class="line"><a name="l00150"></a><span class="lineno">  150</span>&#160;        <span class="keywordflow">if</span> self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a449791883d467ffa5ec59f064a215cbe">_setsession_sql</a>:</div>
<div class="line"><a name="l00151"></a><span class="lineno">  151</span>&#160;            <span class="keywordflow">for</span> sql <span class="keywordflow">in</span> self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a449791883d467ffa5ec59f064a215cbe">_setsession_sql</a>:</div>
<div class="line"><a name="l00152"></a><span class="lineno">  152</span>&#160;                self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a2888f08a359c08d37a2752805cb7511f">_con</a>.query(sql)</div>
<div class="line"><a name="l00153"></a><span class="lineno">  153</span>&#160; </div>
<div class="line"><a name="l00154"></a><span class="lineno"><a class="line" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a719d49c21ab6af00aa9dff68e37dfb0c">  154</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a719d49c21ab6af00aa9dff68e37dfb0c">_close</a>(self):</div>
<div class="line"><a name="l00155"></a><span class="lineno">  155</span>&#160;        <span class="stringliteral">&quot;&quot;&quot;Close the tough connection.</span></div>
<div class="line"><a name="l00156"></a><span class="lineno">  156</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00157"></a><span class="lineno">  157</span>&#160;<span class="stringliteral">        You can always close a tough connection with this method</span></div>
<div class="line"><a name="l00158"></a><span class="lineno">  158</span>&#160;<span class="stringliteral">        and it will not complain if you close it more than once.</span></div>
<div class="line"><a name="l00159"></a><span class="lineno">  159</span>&#160;<span class="stringliteral">        &quot;&quot;&quot;</span></div>
<div class="line"><a name="l00160"></a><span class="lineno">  160</span>&#160;        <span class="keywordflow">if</span> <span class="keywordflow">not</span> self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#ae85c40e9aa9781ac7d8fdedbef6c2d86">_closed</a>:</div>
<div class="line"><a name="l00161"></a><span class="lineno">  161</span>&#160;            <span class="keywordflow">try</span>:</div>
<div class="line"><a name="l00162"></a><span class="lineno">  162</span>&#160;                self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a2888f08a359c08d37a2752805cb7511f">_con</a>.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#ab93eb6dcf95f6a73f25db9752bb05487">close</a>()</div>
<div class="line"><a name="l00163"></a><span class="lineno">  163</span>&#160;            <span class="keywordflow">except</span> Exception:</div>
<div class="line"><a name="l00164"></a><span class="lineno">  164</span>&#160;                <span class="keywordflow">pass</span></div>
<div class="line"><a name="l00165"></a><span class="lineno">  165</span>&#160;            self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a58bb438b542ef47ccc93018fffc59464">_transaction</a> = <span class="keyword">False</span></div>
<div class="line"><a name="l00166"></a><span class="lineno">  166</span>&#160;            self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#ae85c40e9aa9781ac7d8fdedbef6c2d86">_closed</a> = <span class="keyword">True</span></div>
<div class="line"><a name="l00167"></a><span class="lineno">  167</span>&#160; </div>
<div class="line"><a name="l00168"></a><span class="lineno"><a class="line" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#ab93eb6dcf95f6a73f25db9752bb05487">  168</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#ab93eb6dcf95f6a73f25db9752bb05487">close</a>(self):</div>
<div class="line"><a name="l00169"></a><span class="lineno">  169</span>&#160;        <span class="stringliteral">&quot;&quot;&quot;Close the tough connection.</span></div>
<div class="line"><a name="l00170"></a><span class="lineno">  170</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00171"></a><span class="lineno">  171</span>&#160;<span class="stringliteral">        You are allowed to close a tough connection by default</span></div>
<div class="line"><a name="l00172"></a><span class="lineno">  172</span>&#160;<span class="stringliteral">        and it will not complain if you close it more than once.</span></div>
<div class="line"><a name="l00173"></a><span class="lineno">  173</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00174"></a><span class="lineno">  174</span>&#160;<span class="stringliteral">        You can disallow closing connections by setting</span></div>
<div class="line"><a name="l00175"></a><span class="lineno">  175</span>&#160;<span class="stringliteral">        the closeable parameter to something false.  In this case,</span></div>
<div class="line"><a name="l00176"></a><span class="lineno">  176</span>&#160;<span class="stringliteral">        closing tough connections will be silently ignored.</span></div>
<div class="line"><a name="l00177"></a><span class="lineno">  177</span>&#160;<span class="stringliteral">        &quot;&quot;&quot;</span></div>
<div class="line"><a name="l00178"></a><span class="lineno">  178</span>&#160;        <span class="keywordflow">if</span> self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a96596fafba584aa9ef023d40cdf75733">_closeable</a>:</div>
<div class="line"><a name="l00179"></a><span class="lineno">  179</span>&#160;            self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a719d49c21ab6af00aa9dff68e37dfb0c">_close</a>()</div>
<div class="line"><a name="l00180"></a><span class="lineno">  180</span>&#160;        <span class="keywordflow">elif</span> self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a58bb438b542ef47ccc93018fffc59464">_transaction</a>:</div>
<div class="line"><a name="l00181"></a><span class="lineno">  181</span>&#160;            self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#ab014bb85b61d33e1bec90d6eecab3376">reset</a>()</div>
<div class="line"><a name="l00182"></a><span class="lineno">  182</span>&#160; </div>
<div class="line"><a name="l00183"></a><span class="lineno"><a class="line" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#ad60570a52219f884f8198efb062809ea">  183</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#ad60570a52219f884f8198efb062809ea">reopen</a>(self):</div>
<div class="line"><a name="l00184"></a><span class="lineno">  184</span>&#160;        <span class="stringliteral">&quot;&quot;&quot;Reopen the tough connection.</span></div>
<div class="line"><a name="l00185"></a><span class="lineno">  185</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00186"></a><span class="lineno">  186</span>&#160;<span class="stringliteral">        It will not complain if the connection cannot be reopened.</span></div>
<div class="line"><a name="l00187"></a><span class="lineno">  187</span>&#160;<span class="stringliteral">        &quot;&quot;&quot;</span></div>
<div class="line"><a name="l00188"></a><span class="lineno">  188</span>&#160;        <span class="keywordflow">try</span>:</div>
<div class="line"><a name="l00189"></a><span class="lineno">  189</span>&#160;            self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a2888f08a359c08d37a2752805cb7511f">_con</a>.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#ad60570a52219f884f8198efb062809ea">reopen</a>()</div>
<div class="line"><a name="l00190"></a><span class="lineno">  190</span>&#160;        <span class="keywordflow">except</span> Exception:</div>
<div class="line"><a name="l00191"></a><span class="lineno">  191</span>&#160;            <span class="keywordflow">if</span> self._transcation:</div>
<div class="line"><a name="l00192"></a><span class="lineno">  192</span>&#160;                self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a58bb438b542ef47ccc93018fffc59464">_transaction</a> = <span class="keyword">False</span></div>
<div class="line"><a name="l00193"></a><span class="lineno">  193</span>&#160;                <span class="keywordflow">try</span>:</div>
<div class="line"><a name="l00194"></a><span class="lineno">  194</span>&#160;                    self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a2888f08a359c08d37a2752805cb7511f">_con</a>.query(<span class="stringliteral">&#39;rollback&#39;</span>)</div>
<div class="line"><a name="l00195"></a><span class="lineno">  195</span>&#160;                <span class="keywordflow">except</span> Exception:</div>
<div class="line"><a name="l00196"></a><span class="lineno">  196</span>&#160;                    <span class="keywordflow">pass</span></div>
<div class="line"><a name="l00197"></a><span class="lineno">  197</span>&#160;        <span class="keywordflow">else</span>:</div>
<div class="line"><a name="l00198"></a><span class="lineno">  198</span>&#160;            self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a58bb438b542ef47ccc93018fffc59464">_transaction</a> = <span class="keyword">False</span></div>
<div class="line"><a name="l00199"></a><span class="lineno">  199</span>&#160;            self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#ae85c40e9aa9781ac7d8fdedbef6c2d86">_closed</a> = <span class="keyword">False</span></div>
<div class="line"><a name="l00200"></a><span class="lineno">  200</span>&#160;            self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a25fbdaacc83bdca3812d6f2d90f6abcf">_setsession</a>()</div>
<div class="line"><a name="l00201"></a><span class="lineno">  201</span>&#160;            self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#aa1ca602a90359ca6ab85dee23b6c272f">_usage</a> = 0</div>
<div class="line"><a name="l00202"></a><span class="lineno">  202</span>&#160; </div>
<div class="line"><a name="l00203"></a><span class="lineno"><a class="line" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#ab014bb85b61d33e1bec90d6eecab3376">  203</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#ab014bb85b61d33e1bec90d6eecab3376">reset</a>(self):</div>
<div class="line"><a name="l00204"></a><span class="lineno">  204</span>&#160;        <span class="stringliteral">&quot;&quot;&quot;Reset the tough connection.</span></div>
<div class="line"><a name="l00205"></a><span class="lineno">  205</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00206"></a><span class="lineno">  206</span>&#160;<span class="stringliteral">        If a reset is not possible, tries to reopen the connection.</span></div>
<div class="line"><a name="l00207"></a><span class="lineno">  207</span>&#160;<span class="stringliteral">        It will not complain if the connection is already closed.</span></div>
<div class="line"><a name="l00208"></a><span class="lineno">  208</span>&#160;<span class="stringliteral">        &quot;&quot;&quot;</span></div>
<div class="line"><a name="l00209"></a><span class="lineno">  209</span>&#160;        <span class="keywordflow">try</span>:</div>
<div class="line"><a name="l00210"></a><span class="lineno">  210</span>&#160;            self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a2888f08a359c08d37a2752805cb7511f">_con</a>.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#ab014bb85b61d33e1bec90d6eecab3376">reset</a>()</div>
<div class="line"><a name="l00211"></a><span class="lineno">  211</span>&#160;            self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a58bb438b542ef47ccc93018fffc59464">_transaction</a> = <span class="keyword">False</span></div>
<div class="line"><a name="l00212"></a><span class="lineno">  212</span>&#160;            self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a25fbdaacc83bdca3812d6f2d90f6abcf">_setsession</a>()</div>
<div class="line"><a name="l00213"></a><span class="lineno">  213</span>&#160;            self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#aa1ca602a90359ca6ab85dee23b6c272f">_usage</a> = 0</div>
<div class="line"><a name="l00214"></a><span class="lineno">  214</span>&#160;        <span class="keywordflow">except</span> Exception:</div>
<div class="line"><a name="l00215"></a><span class="lineno">  215</span>&#160;            <span class="keywordflow">try</span>:</div>
<div class="line"><a name="l00216"></a><span class="lineno">  216</span>&#160;                self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#ad60570a52219f884f8198efb062809ea">reopen</a>()</div>
<div class="line"><a name="l00217"></a><span class="lineno">  217</span>&#160;            <span class="keywordflow">except</span> Exception:</div>
<div class="line"><a name="l00218"></a><span class="lineno">  218</span>&#160;                <span class="keywordflow">try</span>:</div>
<div class="line"><a name="l00219"></a><span class="lineno">  219</span>&#160;                    self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a08e7af97b9d6bfc6a72abe5384405c87">rollback</a>()</div>
<div class="line"><a name="l00220"></a><span class="lineno">  220</span>&#160;                <span class="keywordflow">except</span> Exception:</div>
<div class="line"><a name="l00221"></a><span class="lineno">  221</span>&#160;                    <span class="keywordflow">pass</span></div>
<div class="line"><a name="l00222"></a><span class="lineno">  222</span>&#160; </div>
<div class="line"><a name="l00223"></a><span class="lineno"><a class="line" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a998a2f8834ffb7e037a34dc6b6a35f5f">  223</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a998a2f8834ffb7e037a34dc6b6a35f5f">begin</a>(self, sql=None):</div>
<div class="line"><a name="l00224"></a><span class="lineno">  224</span>&#160;        <span class="stringliteral">&quot;&quot;&quot;Begin a transaction.&quot;&quot;&quot;</span></div>
<div class="line"><a name="l00225"></a><span class="lineno">  225</span>&#160;        self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a58bb438b542ef47ccc93018fffc59464">_transaction</a> = <span class="keyword">True</span></div>
<div class="line"><a name="l00226"></a><span class="lineno">  226</span>&#160;        <span class="keywordflow">try</span>:</div>
<div class="line"><a name="l00227"></a><span class="lineno">  227</span>&#160;            begin = self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a2888f08a359c08d37a2752805cb7511f">_con</a>.begin</div>
<div class="line"><a name="l00228"></a><span class="lineno">  228</span>&#160;        <span class="keywordflow">except</span> AttributeError:</div>
<div class="line"><a name="l00229"></a><span class="lineno">  229</span>&#160;            <span class="keywordflow">return</span> self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a2888f08a359c08d37a2752805cb7511f">_con</a>.query(sql <span class="keywordflow">or</span> <span class="stringliteral">&#39;begin&#39;</span>)</div>
<div class="line"><a name="l00230"></a><span class="lineno">  230</span>&#160;        <span class="keywordflow">else</span>:</div>
<div class="line"><a name="l00231"></a><span class="lineno">  231</span>&#160;            <span class="comment"># use existing method if available</span></div>
<div class="line"><a name="l00232"></a><span class="lineno">  232</span>&#160;            <span class="keywordflow">if</span> sql:</div>
<div class="line"><a name="l00233"></a><span class="lineno">  233</span>&#160;                <span class="keywordflow">return</span> <a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a998a2f8834ffb7e037a34dc6b6a35f5f">begin</a>(sql=sql)</div>
<div class="line"><a name="l00234"></a><span class="lineno">  234</span>&#160;            <span class="keywordflow">else</span>:</div>
<div class="line"><a name="l00235"></a><span class="lineno">  235</span>&#160;                <span class="keywordflow">return</span> <a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a998a2f8834ffb7e037a34dc6b6a35f5f">begin</a>()</div>
<div class="line"><a name="l00236"></a><span class="lineno">  236</span>&#160; </div>
<div class="line"><a name="l00237"></a><span class="lineno"><a class="line" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a967b9883d55b0fc5ae6b1472666c2079">  237</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a967b9883d55b0fc5ae6b1472666c2079">end</a>(self, sql=None):</div>
<div class="line"><a name="l00238"></a><span class="lineno">  238</span>&#160;        <span class="stringliteral">&quot;&quot;&quot;Commit the current transaction.&quot;&quot;&quot;</span></div>
<div class="line"><a name="l00239"></a><span class="lineno">  239</span>&#160;        self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a58bb438b542ef47ccc93018fffc59464">_transaction</a> = <span class="keyword">False</span></div>
<div class="line"><a name="l00240"></a><span class="lineno">  240</span>&#160;        <span class="keywordflow">try</span>:</div>
<div class="line"><a name="l00241"></a><span class="lineno">  241</span>&#160;            end = self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a2888f08a359c08d37a2752805cb7511f">_con</a>.end</div>
<div class="line"><a name="l00242"></a><span class="lineno">  242</span>&#160;        <span class="keywordflow">except</span> AttributeError:</div>
<div class="line"><a name="l00243"></a><span class="lineno">  243</span>&#160;            <span class="keywordflow">return</span> self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a2888f08a359c08d37a2752805cb7511f">_con</a>.query(sql <span class="keywordflow">or</span> <span class="stringliteral">&#39;end&#39;</span>)</div>
<div class="line"><a name="l00244"></a><span class="lineno">  244</span>&#160;        <span class="keywordflow">else</span>:</div>
<div class="line"><a name="l00245"></a><span class="lineno">  245</span>&#160;            <span class="keywordflow">if</span> sql:</div>
<div class="line"><a name="l00246"></a><span class="lineno">  246</span>&#160;                <span class="keywordflow">return</span> <a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a967b9883d55b0fc5ae6b1472666c2079">end</a>(sql=sql)</div>
<div class="line"><a name="l00247"></a><span class="lineno">  247</span>&#160;            <span class="keywordflow">else</span>:</div>
<div class="line"><a name="l00248"></a><span class="lineno">  248</span>&#160;                <span class="keywordflow">return</span> <a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a967b9883d55b0fc5ae6b1472666c2079">end</a>()</div>
<div class="line"><a name="l00249"></a><span class="lineno">  249</span>&#160; </div>
<div class="line"><a name="l00250"></a><span class="lineno"><a class="line" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#ad6e454534d5834aba8b9552e209602fd">  250</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#ad6e454534d5834aba8b9552e209602fd">commit</a>(self, sql=None):</div>
<div class="line"><a name="l00251"></a><span class="lineno">  251</span>&#160;        <span class="stringliteral">&quot;&quot;&quot;Commit the current transaction.&quot;&quot;&quot;</span></div>
<div class="line"><a name="l00252"></a><span class="lineno">  252</span>&#160;        self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a58bb438b542ef47ccc93018fffc59464">_transaction</a> = <span class="keyword">False</span></div>
<div class="line"><a name="l00253"></a><span class="lineno">  253</span>&#160;        <span class="keywordflow">try</span>:</div>
<div class="line"><a name="l00254"></a><span class="lineno">  254</span>&#160;            commit = self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a2888f08a359c08d37a2752805cb7511f">_con</a>.commit</div>
<div class="line"><a name="l00255"></a><span class="lineno">  255</span>&#160;        <span class="keywordflow">except</span> AttributeError:</div>
<div class="line"><a name="l00256"></a><span class="lineno">  256</span>&#160;            <span class="keywordflow">return</span> self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a2888f08a359c08d37a2752805cb7511f">_con</a>.query(sql <span class="keywordflow">or</span> <span class="stringliteral">&#39;commit&#39;</span>)</div>
<div class="line"><a name="l00257"></a><span class="lineno">  257</span>&#160;        <span class="keywordflow">else</span>:</div>
<div class="line"><a name="l00258"></a><span class="lineno">  258</span>&#160;            <span class="keywordflow">if</span> sql:</div>
<div class="line"><a name="l00259"></a><span class="lineno">  259</span>&#160;                <span class="keywordflow">return</span> <a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#ad6e454534d5834aba8b9552e209602fd">commit</a>(sql=sql)</div>
<div class="line"><a name="l00260"></a><span class="lineno">  260</span>&#160;            <span class="keywordflow">else</span>:</div>
<div class="line"><a name="l00261"></a><span class="lineno">  261</span>&#160;                <span class="keywordflow">return</span> <a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#ad6e454534d5834aba8b9552e209602fd">commit</a>()</div>
<div class="line"><a name="l00262"></a><span class="lineno">  262</span>&#160; </div>
<div class="line"><a name="l00263"></a><span class="lineno"><a class="line" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a08e7af97b9d6bfc6a72abe5384405c87">  263</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a08e7af97b9d6bfc6a72abe5384405c87">rollback</a>(self, sql=None):</div>
<div class="line"><a name="l00264"></a><span class="lineno">  264</span>&#160;        <span class="stringliteral">&quot;&quot;&quot;Rollback the current transaction.&quot;&quot;&quot;</span></div>
<div class="line"><a name="l00265"></a><span class="lineno">  265</span>&#160;        self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a58bb438b542ef47ccc93018fffc59464">_transaction</a> = <span class="keyword">False</span></div>
<div class="line"><a name="l00266"></a><span class="lineno">  266</span>&#160;        <span class="keywordflow">try</span>:</div>
<div class="line"><a name="l00267"></a><span class="lineno">  267</span>&#160;            rollback = self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a2888f08a359c08d37a2752805cb7511f">_con</a>.rollback</div>
<div class="line"><a name="l00268"></a><span class="lineno">  268</span>&#160;        <span class="keywordflow">except</span> AttributeError:</div>
<div class="line"><a name="l00269"></a><span class="lineno">  269</span>&#160;            <span class="keywordflow">return</span> self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a2888f08a359c08d37a2752805cb7511f">_con</a>.query(sql <span class="keywordflow">or</span> <span class="stringliteral">&#39;rollback&#39;</span>)</div>
<div class="line"><a name="l00270"></a><span class="lineno">  270</span>&#160;        <span class="keywordflow">else</span>:</div>
<div class="line"><a name="l00271"></a><span class="lineno">  271</span>&#160;            <span class="keywordflow">if</span> sql:</div>
<div class="line"><a name="l00272"></a><span class="lineno">  272</span>&#160;                <span class="keywordflow">return</span> <a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a08e7af97b9d6bfc6a72abe5384405c87">rollback</a>(sql=sql)</div>
<div class="line"><a name="l00273"></a><span class="lineno">  273</span>&#160;            <span class="keywordflow">else</span>:</div>
<div class="line"><a name="l00274"></a><span class="lineno">  274</span>&#160;                <span class="keywordflow">return</span> <a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a08e7af97b9d6bfc6a72abe5384405c87">rollback</a>()</div>
<div class="line"><a name="l00275"></a><span class="lineno">  275</span>&#160; </div>
<div class="line"><a name="l00276"></a><span class="lineno"><a class="line" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a7d9cd4c6ec3d929fdb84ab50e7a73b9a">  276</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a7d9cd4c6ec3d929fdb84ab50e7a73b9a">_get_tough_method</a>(self, method):</div>
<div class="line"><a name="l00277"></a><span class="lineno">  277</span>&#160;        <span class="stringliteral">&quot;&quot;&quot;Return a &quot;tough&quot; version of a connection class method.</span></div>
<div class="line"><a name="l00278"></a><span class="lineno">  278</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00279"></a><span class="lineno">  279</span>&#160;<span class="stringliteral">        The tough version checks whether the connection is bad (lost)</span></div>
<div class="line"><a name="l00280"></a><span class="lineno">  280</span>&#160;<span class="stringliteral">        and automatically and transparently tries to reset the connection</span></div>
<div class="line"><a name="l00281"></a><span class="lineno">  281</span>&#160;<span class="stringliteral">        if this is the case (for instance, the database has been restarted).</span></div>
<div class="line"><a name="l00282"></a><span class="lineno">  282</span>&#160;<span class="stringliteral">        &quot;&quot;&quot;</span></div>
<div class="line"><a name="l00283"></a><span class="lineno">  283</span>&#160; </div>
<div class="line"><a name="l00284"></a><span class="lineno">  284</span>&#160;        <span class="keyword">def </span>tough_method(*args, **kwargs):</div>
<div class="line"><a name="l00285"></a><span class="lineno">  285</span>&#160;            transaction = self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a58bb438b542ef47ccc93018fffc59464">_transaction</a></div>
<div class="line"><a name="l00286"></a><span class="lineno">  286</span>&#160;            <span class="keywordflow">if</span> <span class="keywordflow">not</span> transaction:</div>
<div class="line"><a name="l00287"></a><span class="lineno">  287</span>&#160;                <span class="keywordflow">try</span>:</div>
<div class="line"><a name="l00288"></a><span class="lineno">  288</span>&#160;                    <span class="comment"># check whether connection status is bad</span></div>
<div class="line"><a name="l00289"></a><span class="lineno">  289</span>&#160;                    <span class="comment"># or the connection has been used too often</span></div>
<div class="line"><a name="l00290"></a><span class="lineno">  290</span>&#160;                    <span class="keywordflow">if</span> <span class="keywordflow">not</span> self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a2888f08a359c08d37a2752805cb7511f">_con</a>.db.status <span class="keywordflow">or</span> (</div>
<div class="line"><a name="l00291"></a><span class="lineno">  291</span>&#160;                            self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a8a7f70255537edb3269127924edeb0d6">_maxusage</a> <span class="keywordflow">and</span> self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#aa1ca602a90359ca6ab85dee23b6c272f">_usage</a> &gt;= self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a8a7f70255537edb3269127924edeb0d6">_maxusage</a>):</div>
<div class="line"><a name="l00292"></a><span class="lineno">  292</span>&#160;                        <span class="keywordflow">raise</span> AttributeError</div>
<div class="line"><a name="l00293"></a><span class="lineno">  293</span>&#160;                <span class="keywordflow">except</span> Exception:</div>
<div class="line"><a name="l00294"></a><span class="lineno">  294</span>&#160;                    self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#ab014bb85b61d33e1bec90d6eecab3376">reset</a>()  <span class="comment"># then reset the connection</span></div>
<div class="line"><a name="l00295"></a><span class="lineno">  295</span>&#160;            <span class="keywordflow">try</span>:</div>
<div class="line"><a name="l00296"></a><span class="lineno">  296</span>&#160;                result = method(*args, **kwargs)  <span class="comment"># try connection method</span></div>
<div class="line"><a name="l00297"></a><span class="lineno">  297</span>&#160;            <span class="keywordflow">except</span> Exception:  <span class="comment"># error in query</span></div>
<div class="line"><a name="l00298"></a><span class="lineno">  298</span>&#160;                <span class="keywordflow">if</span> transaction:  <span class="comment"># inside a transaction</span></div>
<div class="line"><a name="l00299"></a><span class="lineno">  299</span>&#160;                    self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a58bb438b542ef47ccc93018fffc59464">_transaction</a> = <span class="keyword">False</span></div>
<div class="line"><a name="l00300"></a><span class="lineno">  300</span>&#160;                    <span class="keywordflow">raise</span>  <span class="comment"># propagate the error</span></div>
<div class="line"><a name="l00301"></a><span class="lineno">  301</span>&#160;                <span class="keywordflow">elif</span> self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a2888f08a359c08d37a2752805cb7511f">_con</a>.db.status:  <span class="comment"># if it was not a connection problem</span></div>
<div class="line"><a name="l00302"></a><span class="lineno">  302</span>&#160;                    <span class="keywordflow">raise</span>  <span class="comment"># then propagate the error</span></div>
<div class="line"><a name="l00303"></a><span class="lineno">  303</span>&#160;                <span class="keywordflow">else</span>:  <span class="comment"># otherwise</span></div>
<div class="line"><a name="l00304"></a><span class="lineno">  304</span>&#160;                    self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#ab014bb85b61d33e1bec90d6eecab3376">reset</a>()  <span class="comment"># reset the connection</span></div>
<div class="line"><a name="l00305"></a><span class="lineno">  305</span>&#160;                    result = method(*args, **kwargs)  <span class="comment"># and try one more time</span></div>
<div class="line"><a name="l00306"></a><span class="lineno">  306</span>&#160;            self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#aa1ca602a90359ca6ab85dee23b6c272f">_usage</a> += 1</div>
<div class="line"><a name="l00307"></a><span class="lineno">  307</span>&#160;            <span class="keywordflow">return</span> result</div>
<div class="line"><a name="l00308"></a><span class="lineno">  308</span>&#160; </div>
<div class="line"><a name="l00309"></a><span class="lineno">  309</span>&#160;        <span class="keywordflow">return</span> tough_method</div>
<div class="line"><a name="l00310"></a><span class="lineno">  310</span>&#160; </div>
<div class="line"><a name="l00311"></a><span class="lineno"><a class="line" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#affbaa24a76e047892dbe2178c7c2b3e6">  311</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#affbaa24a76e047892dbe2178c7c2b3e6">__getattr__</a>(self, name):</div>
<div class="line"><a name="l00312"></a><span class="lineno">  312</span>&#160;        <span class="stringliteral">&quot;&quot;&quot;Inherit the members of the standard connection class.</span></div>
<div class="line"><a name="l00313"></a><span class="lineno">  313</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00314"></a><span class="lineno">  314</span>&#160;<span class="stringliteral">        Some methods are made &quot;tougher&quot; than in the standard version.</span></div>
<div class="line"><a name="l00315"></a><span class="lineno">  315</span>&#160;<span class="stringliteral">        &quot;&quot;&quot;</span></div>
<div class="line"><a name="l00316"></a><span class="lineno">  316</span>&#160;        <span class="keywordflow">if</span> self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a2888f08a359c08d37a2752805cb7511f">_con</a>:</div>
<div class="line"><a name="l00317"></a><span class="lineno">  317</span>&#160;            attr = getattr(self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a2888f08a359c08d37a2752805cb7511f">_con</a>, name)</div>
<div class="line"><a name="l00318"></a><span class="lineno">  318</span>&#160;            <span class="keywordflow">if</span> (name <span class="keywordflow">in</span> (<span class="stringliteral">&#39;query&#39;</span>, <span class="stringliteral">&#39;get&#39;</span>, <span class="stringliteral">&#39;insert&#39;</span>, <span class="stringliteral">&#39;update&#39;</span>, <span class="stringliteral">&#39;delete&#39;</span>)</div>
<div class="line"><a name="l00319"></a><span class="lineno">  319</span>&#160;                    <span class="keywordflow">or</span> name.startswith(<span class="stringliteral">&#39;get_&#39;</span>)):</div>
<div class="line"><a name="l00320"></a><span class="lineno">  320</span>&#160;                attr = self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a7d9cd4c6ec3d929fdb84ab50e7a73b9a">_get_tough_method</a>(attr)</div>
<div class="line"><a name="l00321"></a><span class="lineno">  321</span>&#160;            <span class="keywordflow">return</span> attr</div>
<div class="line"><a name="l00322"></a><span class="lineno">  322</span>&#160;        <span class="keywordflow">else</span>:</div>
<div class="line"><a name="l00323"></a><span class="lineno">  323</span>&#160;            <span class="keywordflow">raise</span> InvalidConnection</div>
<div class="line"><a name="l00324"></a><span class="lineno">  324</span>&#160; </div>
<div class="line"><a name="l00325"></a><span class="lineno"><a class="line" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#afef240935d1bbc5d6039755fc6378a94">  325</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#afef240935d1bbc5d6039755fc6378a94">__del__</a>(self):</div>
<div class="line"><a name="l00326"></a><span class="lineno">  326</span>&#160;        <span class="stringliteral">&quot;&quot;&quot;Delete the steady connection.&quot;&quot;&quot;</span></div>
<div class="line"><a name="l00327"></a><span class="lineno">  327</span>&#160;        <span class="keywordflow">try</span>:</div>
<div class="line"><a name="l00328"></a><span class="lineno">  328</span>&#160;            self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a719d49c21ab6af00aa9dff68e37dfb0c">_close</a>()  <span class="comment"># make sure the connection is closed</span></div>
<div class="line"><a name="l00329"></a><span class="lineno">  329</span>&#160;        <span class="keywordflow">except</span>:  <span class="comment"># builtin Exceptions might not exist any more</span></div>
<div class="line"><a name="l00330"></a><span class="lineno">  330</span>&#160;            <span class="keywordflow">pass</span></div>
</div><!-- fragment --></div><!-- contents -->
<div class="ttc" id="aclassaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection_html_a998a2f8834ffb7e037a34dc6b6a35f5f"><div class="ttname"><a href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a998a2f8834ffb7e037a34dc6b6a35f5f">aestate.opera.DBPool.steady_pg.SteadyPgConnection.begin</a></div><div class="ttdeci">def begin(self, sql=None)</div><div class="ttdef"><b>Definition:</b> <a href="steady__pg_8py_source.html#l00223">steady_pg.py:223</a></div></div>
<div class="ttc" id="aclassaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection_html_a8a7f70255537edb3269127924edeb0d6"><div class="ttname"><a href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a8a7f70255537edb3269127924edeb0d6">aestate.opera.DBPool.steady_pg.SteadyPgConnection._maxusage</a></div><div class="ttdeci">_maxusage</div><div class="ttdef"><b>Definition:</b> <a href="steady__pg_8py_source.html#l00125">steady_pg.py:125</a></div></div>
<div class="ttc" id="aclassaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection_html_a384a69210d735cbf8d5fce77aadc9610"><div class="ttname"><a href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a384a69210d735cbf8d5fce77aadc9610">aestate.opera.DBPool.steady_pg.SteadyPgConnection.__exit__</a></div><div class="ttdeci">def __exit__(self, *exc)</div><div class="ttdef"><b>Definition:</b> <a href="steady__pg_8py_source.html#l00141">steady_pg.py:141</a></div></div>
<div class="ttc" id="aclassaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection_html_a96596fafba584aa9ef023d40cdf75733"><div class="ttname"><a href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a96596fafba584aa9ef023d40cdf75733">aestate.opera.DBPool.steady_pg.SteadyPgConnection._closeable</a></div><div class="ttdeci">_closeable</div><div class="ttdef"><b>Definition:</b> <a href="steady__pg_8py_source.html#l00127">steady_pg.py:127</a></div></div>
<div class="ttc" id="aclassaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection_html_a4ed3a76224573ad1f57299573d92f080"><div class="ttname"><a href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a4ed3a76224573ad1f57299573d92f080">aestate.opera.DBPool.steady_pg.SteadyPgConnection.__enter__</a></div><div class="ttdeci">def __enter__(self)</div><div class="ttdef"><b>Definition:</b> <a href="steady__pg_8py_source.html#l00136">steady_pg.py:136</a></div></div>
<div class="ttc" id="aclassaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection_html_a2888f08a359c08d37a2752805cb7511f"><div class="ttname"><a href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a2888f08a359c08d37a2752805cb7511f">aestate.opera.DBPool.steady_pg.SteadyPgConnection._con</a></div><div class="ttdeci">_con</div><div class="ttdef"><b>Definition:</b> <a href="steady__pg_8py_source.html#l00118">steady_pg.py:118</a></div></div>
<div class="ttc" id="aclassaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection_html_affbaa24a76e047892dbe2178c7c2b3e6"><div class="ttname"><a href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#affbaa24a76e047892dbe2178c7c2b3e6">aestate.opera.DBPool.steady_pg.SteadyPgConnection.__getattr__</a></div><div class="ttdeci">def __getattr__(self, name)</div><div class="ttdef"><b>Definition:</b> <a href="steady__pg_8py_source.html#l00311">steady_pg.py:311</a></div></div>
<div class="ttc" id="aclassaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection_html_afef240935d1bbc5d6039755fc6378a94"><div class="ttname"><a href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#afef240935d1bbc5d6039755fc6378a94">aestate.opera.DBPool.steady_pg.SteadyPgConnection.__del__</a></div><div class="ttdeci">def __del__(self)</div><div class="ttdef"><b>Definition:</b> <a href="steady__pg_8py_source.html#l00325">steady_pg.py:325</a></div></div>
<div class="ttc" id="aclassaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection_html_ab014bb85b61d33e1bec90d6eecab3376"><div class="ttname"><a href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#ab014bb85b61d33e1bec90d6eecab3376">aestate.opera.DBPool.steady_pg.SteadyPgConnection.reset</a></div><div class="ttdeci">def reset(self)</div><div class="ttdef"><b>Definition:</b> <a href="steady__pg_8py_source.html#l00203">steady_pg.py:203</a></div></div>
<div class="ttc" id="aclassaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_error_html"><div class="ttname"><a href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_error.html">aestate.opera.DBPool.steady_pg.SteadyPgError</a></div><div class="ttdef"><b>Definition:</b> <a href="steady__pg_8py_source.html#l00082">steady_pg.py:82</a></div></div>
<div class="ttc" id="aclassaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection_html_a36c68c399eb77d8031565f82e9630540"><div class="ttname"><a href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a36c68c399eb77d8031565f82e9630540">aestate.opera.DBPool.steady_pg.SteadyPgConnection.__init__</a></div><div class="ttdeci">def __init__(self, maxusage=None, setsession=None, closeable=True, *args, **kwargs)</div><div class="ttdef"><b>Definition:</b> <a href="steady__pg_8py_source.html#l00104">steady_pg.py:104</a></div></div>
<div class="ttc" id="aclassaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection_html_a25fbdaacc83bdca3812d6f2d90f6abcf"><div class="ttname"><a href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a25fbdaacc83bdca3812d6f2d90f6abcf">aestate.opera.DBPool.steady_pg.SteadyPgConnection._setsession</a></div><div class="ttdeci">def _setsession(self)</div><div class="ttdef"><b>Definition:</b> <a href="steady__pg_8py_source.html#l00148">steady_pg.py:148</a></div></div>
<div class="ttc" id="aclassaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection_html_a08e7af97b9d6bfc6a72abe5384405c87"><div class="ttname"><a href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a08e7af97b9d6bfc6a72abe5384405c87">aestate.opera.DBPool.steady_pg.SteadyPgConnection.rollback</a></div><div class="ttdeci">def rollback(self, sql=None)</div><div class="ttdef"><b>Definition:</b> <a href="steady__pg_8py_source.html#l00263">steady_pg.py:263</a></div></div>
<div class="ttc" id="aclassaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection_html_aa1ca602a90359ca6ab85dee23b6c272f"><div class="ttname"><a href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#aa1ca602a90359ca6ab85dee23b6c272f">aestate.opera.DBPool.steady_pg.SteadyPgConnection._usage</a></div><div class="ttdeci">_usage</div><div class="ttdef"><b>Definition:</b> <a href="steady__pg_8py_source.html#l00132">steady_pg.py:132</a></div></div>
<div class="ttc" id="aclassaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection_html_ad6e454534d5834aba8b9552e209602fd"><div class="ttname"><a href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#ad6e454534d5834aba8b9552e209602fd">aestate.opera.DBPool.steady_pg.SteadyPgConnection.commit</a></div><div class="ttdeci">def commit(self, sql=None)</div><div class="ttdef"><b>Definition:</b> <a href="steady__pg_8py_source.html#l00250">steady_pg.py:250</a></div></div>
<div class="ttc" id="aclassaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_invalid_connection_html"><div class="ttname"><a href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_invalid_connection.html">aestate.opera.DBPool.steady_pg.InvalidConnection</a></div><div class="ttdef"><b>Definition:</b> <a href="steady__pg_8py_source.html#l00086">steady_pg.py:86</a></div></div>
<div class="ttc" id="aclassaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection_html_a58bb438b542ef47ccc93018fffc59464"><div class="ttname"><a href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a58bb438b542ef47ccc93018fffc59464">aestate.opera.DBPool.steady_pg.SteadyPgConnection._transaction</a></div><div class="ttdeci">_transaction</div><div class="ttdef"><b>Definition:</b> <a href="steady__pg_8py_source.html#l00129">steady_pg.py:129</a></div></div>
<div class="ttc" id="aclassaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection_html_a449791883d467ffa5ec59f064a215cbe"><div class="ttname"><a href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a449791883d467ffa5ec59f064a215cbe">aestate.opera.DBPool.steady_pg.SteadyPgConnection._setsession_sql</a></div><div class="ttdeci">_setsession_sql</div><div class="ttdef"><b>Definition:</b> <a href="steady__pg_8py_source.html#l00126">steady_pg.py:126</a></div></div>
<div class="ttc" id="aclassaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection_html"><div class="ttname"><a href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html">aestate.opera.DBPool.steady_pg.SteadyPgConnection</a></div><div class="ttdef"><b>Definition:</b> <a href="steady__pg_8py_source.html#l00090">steady_pg.py:90</a></div></div>
<div class="ttc" id="aclassaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection_html_a719d49c21ab6af00aa9dff68e37dfb0c"><div class="ttname"><a href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a719d49c21ab6af00aa9dff68e37dfb0c">aestate.opera.DBPool.steady_pg.SteadyPgConnection._close</a></div><div class="ttdeci">def _close(self)</div><div class="ttdef"><b>Definition:</b> <a href="steady__pg_8py_source.html#l00154">steady_pg.py:154</a></div></div>
<div class="ttc" id="aclassaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection_html_ae85c40e9aa9781ac7d8fdedbef6c2d86"><div class="ttname"><a href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#ae85c40e9aa9781ac7d8fdedbef6c2d86">aestate.opera.DBPool.steady_pg.SteadyPgConnection._closed</a></div><div class="ttdeci">_closed</div><div class="ttdef"><b>Definition:</b> <a href="steady__pg_8py_source.html#l00119">steady_pg.py:119</a></div></div>
<div class="ttc" id="aclassaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection_html_ab93eb6dcf95f6a73f25db9752bb05487"><div class="ttname"><a href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#ab93eb6dcf95f6a73f25db9752bb05487">aestate.opera.DBPool.steady_pg.SteadyPgConnection.close</a></div><div class="ttdeci">def close(self)</div><div class="ttdef"><b>Definition:</b> <a href="steady__pg_8py_source.html#l00168">steady_pg.py:168</a></div></div>
<div class="ttc" id="aclassaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection_html_a967b9883d55b0fc5ae6b1472666c2079"><div class="ttname"><a href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a967b9883d55b0fc5ae6b1472666c2079">aestate.opera.DBPool.steady_pg.SteadyPgConnection.end</a></div><div class="ttdeci">def end(self, sql=None)</div><div class="ttdef"><b>Definition:</b> <a href="steady__pg_8py_source.html#l00237">steady_pg.py:237</a></div></div>
<div class="ttc" id="aclassaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection_html_a7d9cd4c6ec3d929fdb84ab50e7a73b9a"><div class="ttname"><a href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#a7d9cd4c6ec3d929fdb84ab50e7a73b9a">aestate.opera.DBPool.steady_pg.SteadyPgConnection._get_tough_method</a></div><div class="ttdeci">def _get_tough_method(self, method)</div><div class="ttdef"><b>Definition:</b> <a href="steady__pg_8py_source.html#l00276">steady_pg.py:276</a></div></div>
<div class="ttc" id="aclassaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection_html_ad60570a52219f884f8198efb062809ea"><div class="ttname"><a href="classaestate_1_1opera_1_1_d_b_pool_1_1steady__pg_1_1_steady_pg_connection.html#ad60570a52219f884f8198efb062809ea">aestate.opera.DBPool.steady_pg.SteadyPgConnection.reopen</a></div><div class="ttdeci">def reopen(self)</div><div class="ttdef"><b>Definition:</b> <a href="steady__pg_8py_source.html#l00183">steady_pg.py:183</a></div></div>
<!-- start footer part -->
<hr class="footer"/><address class="footer"><small>
Generated by &#160;<a href="http://www.doxygen.org/index.html">
<img class="footer" src="doxygen.png" alt="doxygen"/>
</a> 1.8.17
</small></address>
</body>
</html>
